﻿<!DOCTYPE html>
<html>
	<head>
		<title>Collaborative Spreadsheet Editing</title>
		<meta charset="utf-8" />
		<meta name="description" content="Tips on collaborative editing" />
		<link type="text/css" rel="stylesheet" href="../../../../../../common/main/resources/help/editor.css" />
		<link type = "text/css" rel = "stylesheet" href = "../../images/sprite.css" />
        <script type="text/javascript" src="../callback.js"></script>
        <script type="text/javascript" src="../search/js/page-search.js"></script>
	</head>
	<body>
		<div class="mainpart">
        <div class="search-field">
            <input id="search" class="searchBar" placeholder="Search" type="text" onkeypress="doSearch(event)">
        </div>
		<h1>Collaborative Spreadsheet Editing</h1>
			<p><b>Spreadsheet Editor</b> offers you the possibility to work at a spreadsheet collaboratively with other users. This feature includes:</p>
			<ul>
				<li class="onlineDocumentFeatures">simultaneous multi-user access to the edited spreadsheet</li>
				<li class="onlineDocumentFeatures">visual indication of cells that are being edited by other users</li>
				<li class="onlineDocumentFeatures">real-time changes display or synchronization of changes with one button click</li>
				<li class="onlineDocumentFeatures">chat to share ideas concerning particular spreadsheet parts</li>
				<li>comments containing the description of a task or problem that should be solved (it's also possible to work with comments in the offline mode, without connecting to the <em>online version</em>)</li>
			</ul>
            <div class="desktopDocumentFeatures">
                <h3>Connecting to the online version</h3>
                <p>In the <em>desktop editor</em>, open the <b>Connect to cloud</b> option of the left-side menu in the main program window. Connect to your cloud office specifying your account login and password. <!--В окне ввода логина и пароля также доступна ссылка для регистрации в Облаке.--></p>
            </div>
            <div class="onlineDocumentFeatures">
                <h3>Co-editing</h3>
                <p><b>Spreadsheet Editor</b> allows to select one of the two available co-editing modes:</p>   
                <ul>
                    <li><b>Fast</b> is used by default and shows the changes made by other users in real time.</li>
                    <li><b>Strict</b> is selected to hide other user changes until you click the <b>Save</b> <div class = "icon icon-saveupdate"></div> icon to save your own changes and accept the changes made by others.</li>
                </ul>
                <p>The mode can be selected in the <a href="../HelpfulHints/AdvancedSettings.htm" onclick="onhyperlinkclick(this)">Advanced Settings</a>. It's also possible to choose the necessary mode using the <span class="icon icon-coeditingmode"></span> <b>Co-editing Mode</b> icon at the <b>Collaboration</b> tab of the top toolbar:</p>
                <p><img alt="Co-editing Mode menu" src="../../../../../../common/main/resources/help/it/images/coeditingmodemenu.png" /></p>
                <p class="note">
                    <b>Note</b>: when you co-edit a spreadsheet in the <b>Fast</b> mode, the possibility to <b>Undo</b>/<b>Redo</b> the last operation is not available.
                </p>
                <p>When a spreadsheet is being edited by several users simultaneously in the <b>Strict</b> mode, the edited cells as well as the tab of the sheet where these cells are situated are marked with dashed lines of different colors. By hovering the mouse cursor over one of the edited cells, the name of the user who is editing it at the moment is displayed. The <b>Fast</b> mode will show the actions and the names of the co-editors once they are editing the text.</p>
                <p>The number of users who are working at the current spreadsheet is specified on the right side of the editor header - <span class="icon icon-usersnumber"></span>. If you want to see who exactly are editing the file now, you can click this icon or open the <b>Chat</b> panel with the full list of the users.</p>
                <p>When no users are viewing or editing the file, the icon in the editor header will look like <span class="icon icon-access_rights"></span> allowing you to manage the users who have access to the file right from the spreadsheet: invite new users giving them permissions to <em>edit</em>, <em>read</em> or <em>comment</em> the spreadsheet, or <em>deny</em> some users access rights to the file. Click this icon to manage the access to the file; this can be done both when there are no other users who view or co-edit the spreadsheet at the moment and when there are other users and the icon looks like <span class="icon icon-usersnumber"></span>. It's also possible to set access rights using the <span class="icon icon-sharingicon"></span> <b>Sharing</b> icon at the <b>Collaboration</b> tab of the top toolbar.</p>
                <p>As soon as one of the users saves his/her changes by clicking the <span class="icon icon-savewhilecoediting"></span> icon, the others will see a note in the upper left corner stating that they have updates. To save the changes you made, so that other users can view them, and get the updates saved by your co-editors, click the <span class="icon icon-saveupdate"></span> icon in the left upper corner of the top toolbar.</p>
                <h3 id="chat">Chat</h3>
                <p>You can use this tool to coordinate the co-editing process on-the-fly, for example, to arrange with your collaborators about who is doing what, which part of the spreadsheet you are going to edit now etc.</p>
                <p>The chat messages are stored during one session only. To discuss the spreadsheet content it is better to use comments which are stored until you decide to delete them.</p>
                <p>To access the chat and leave a message for other users,</p>
                <ol>
                    <li>click the <div class = "icon icon-chaticon"></div> icon at the left sidebar, or <br />
                    switch to the <b>Collaboration</b> tab of the top toolbar and click the <div class = "icon icon-chat_toptoolbar"></div> <b>Chat</b> button,</li>
                    <li>enter your text into the corresponding field below,</li>
                    <li>press the <b>Send</b> button.</li>
                </ol>
                <p>All the messages left by users will be displayed on the panel on the left. If there are new messages you haven't read yet, the chat icon will look like this - <span class="icon icon-chaticon_new"></span>.</p>
                <p>To close the panel with chat messages, click the <span class="icon icon-chaticon"></span> icon once again.</p>
            </div>
            <h3 id="comments">Comments</h3>
            <p>It's possible to work with comments in the offline mode, without connecting to the <em>online version</em>.</p>
                <p>To leave a comment,</p>
                <ol>
                    <li>select a cell where you think there is an error or problem,</li>
                    <li>switch to the <b>Insert</b> or <b>Collaboration</b> tab of the top toolbar and click the <div class = "icon icon-comment_toptoolbar"></div> <b>Comment</b> button, or<br />
                        use the <div class = "icon icon-commentsicon"></div> icon at the left sidebar to open the <b>Comments</b> panel and click the <b>Add Comment to Document</b> link, or<br />
                        right-click within the selected cell and select the <b>Add Сomment</b> option from the menu,
                    </li>
                    <li>enter the needed text,</li>
                    <li>click the <b>Add Comment</b>/<b>Add</b> button.</li>
                </ol>
                <p>The comment will be seen on the panel on the left. The orange triangle will appear in the upper right corner of the cell you commented. If you need to disable this feature, click the <b>File</b> tab at the top toolbar, select the <b>Advanced Settings...</b> option and uncheck the <b>Turn on display of the comments</b> box. In this case the commented cells will be marked only if you click the <span class="icon icon-commentsicon"></span> icon.</p>
                <p>If you are using the <b>Strict</b> co-editing mode, new comments added by other users will become visible only after you click the <span class="icon icon-saveupdate"></span> icon in the left upper corner of the top toolbar.</p>
                <p>To view the comment, just click within the cell. You or any other user can answer to the added comment asking questions or reporting on the work he/she has done. For this purpose, use the <b>Add Reply</b> link, type in your reply text in the entry field and press the <b>Reply</b> button.</p>
                <p>You can manage the added comments using the icons in the comment balloon or at the <b>Comments</b> panel on the left:</p>
                <ul>
                    <li>edit the currently selected by clicking the <div class = "icon icon-editcommenticon"></div> icon,</li>
                    <li>delete the currently selected by clicking the <div class = "icon icon-deletecommenticon"></div> icon,</li>
                    <li>close the currently selected discussion by clicking the <div class = "icon icon-resolveicon"></div> icon if the task or problem you stated in your comment was solved, after that the discussion you opened with your comment gets the resolved status. To open it again, click the <div class = "icon icon-resolvedicon"></div> icon. If you want to hide resolved comments, click the <b>File</b> tab at the top toolbar, select the <b>Advanced Settings...</b> option, uncheck the <b>Turn on display of the resolved comments</b> box and click <b>Apply</b>. In this case the resolved comments will be highlighted only if you click the <div class = "icon icon-commentsicon"></div> icon.</li>
                </ul>
            <h4>Adding mentions</h4>
            <p>When entering comments, you can use the <b>mentions</b> feature that allows to attract somebody's attention to the comment and send a notification to the mentioned user via email and <b>Talk</b>.</p>
            <p>To add a mention enter the "+" or "@" sign anywhere in the comment text - a list of the portal users will open. To simplify the search process, you can start typing a name in the comment field - the user list will change as you type. Select the necessary person from the list. If the file has not yet been shared with the mentioned user, the <b>Sharing Settings</b> window will open. <b>Read only</b> access type is selected by default. Change it if necessary and click <b>OK</b>.</p>
            <p>The mentioned user will receive an email notification that he/she has been mentioned in a comment. If the file has been shared, the user will also receive a corresponding notification.</p>
            <p>To remove comments,</p>
            <ol>
                <li>click the <div class = "icon icon-removecomment_toptoolbar"></div> <b>Remove</b> button at the <b>Collaboration</b> tab of the top toolbar,</li>
                <li>
                    select the necessary option from the menu:
                    <ul>
                        <li><b>Remove Current Comments</b> - to remove the currently selected comment. If some replies have beed added to the comment, all its replies will be removed as well.</li>
                        <li><b>Remove My Comments</b> - to remove comments you added without removing comments added by other users. If some replies have beed added to your comment, all its replies will be removed as well.</li>
                        <li><b>Remove All Comments</b> - to remove all the comments in the spreadsheet that you and other users added.</li>
                    </ul>
                </li>
            </ol>
                <p>To close the panel with comments, click the <span class="icon icon-commentsicon"></span> icon at the left sidebar once again.</p>
            </div>
	</body>
</html>